Incorrect import of timestamp fields in MS Access with 7.2.x - Mailing list pgsql-odbc

From Edwin Woudt
Subject Incorrect import of timestamp fields in MS Access with 7.2.x
Date
Msg-id 2560552730.1018961753@[10.0.1.4]
Whole thread Raw
List pgsql-odbc
Hi,

After switching from PostgreSQL 7.1.3 to 7.2, I'm having trouble with
timestamp fields in ODBC-linked tables in MS Access (both '97 and XP).

The problem is that MS Access somehow thinks these are 'Text' fields
instead of 'Date/Time' fields. It worked fine when using the 7.1.3 server,
but not with 7.2 and 7.2.1.

I tried different ODBC driver versions, but 7.1.0007, 7.1.0010 and 7.2.0001
all show the same problem.

As this seems to be an ODBC driver related problem, I hope this question is
appropriate on this mailing list. If not, feel free to direct me to another
one.


Edwin


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: unexpected protocol charactor during authentication
Next
From: Hiroshi Inoue
Date:
Subject: Re: Incorrect import of timestamp fields in MS Access with 7.2.x